Desktop Computer Skills
Microsoft Office 2010: Beginning Access
Access 2010: Creating Forms & Queries
ds_msac2010_06_enus
Access 2010: Finding & Organizing Data
ds_msac2010_05_enus
Access 2010: Inserting, Importing, & Formatting Data
ds_msac2010_04_enus
Access 2010: Report & Analysis Tools
ds_msac2010_07_enus
Access 2010: Saving, Protecting, & Exporting Databases
ds_msac2010_02_enus
Access 2010: Understanding Tables, Fields, & Entries
ds_msac2010_03_enus
Access 2010: Working with Databases
ds_msac2010_01_enus
Creating Basic Tables in Access 2010
mo_bacc_a02_dt_enus
Data Manipulation and Simple Relationships in Access 2010
mo_bacc_a03_dt_enus
Getting Started with Access 2010
mo_bacc_a01_dt_enus
Introduction to Forms in Access 2010
mo_bacc_a04_dt_enus
Introduction to Queries in Access 2010
mo_bacc_a06_dt_enus
Introduction to Reports in Access 2010
mo_bacc_a07_dt_enus
Modifying Basic Forms in Access 2010
mo_bacc_a05_dt_enus
Access 2010: Creating Forms & Queries
Lesson Objectives
Access 2010: Creating Forms & Queries
- Creating a data entry form using the wizard
- Creating a data entry form from scratch
- Inserting text in a form
- Inserting data entry fields
- Inserting a list box
- Inserting check boxes
- Inserting buttons
- Reorganizing your form
- Adding information to your form
- Customizing the appearance of your form
- Editing your form's properties
- Creating a simple query
- Creating a crosstab query
- Creating a calculated field
Overview/Description
A form provides an interface where you can insert data into multiple fields from multiple tables via a single screen. Discover how to create and customize forms, and create queries in Access 2010.
Target
Prerequisites: none
Access 2010: Finding & Organizing Data
Lesson Objectives
Access 2010: Finding & Organizing Data
- Sorting your data
- Filtering your data
- Locating a data value
- Replacing data values
- Editing your database indexes
- Finding duplicates in your database
Overview/Description
Organize data for better analysis. Explore sorting and filtering, locating and replacing data values, editing database indexes, and finding duplicates in an Access 2010 database.
Target
Prerequisites: none
Access 2010: Inserting, Importing, & Formatting Data
Lesson Objectives
Access 2010: Inserting, Importing, & Formatting Data
- Inserting data into your table
- Formatting your data
- Creating dropdown menus
- Adjusting your data validation settings
- Using external data in your database
- Importing your address book from Outlook
- Creating labels
Overview/Description
Once you've created fields in Access 2010, you can begin entering and formatting data. Discover how to add and format data, create dropdown menus, configure data validation, use external data, import an address book, and create labels.
Target
Prerequisites: none
Access 2010: Report & Analysis Tools
Lesson Objectives
Access 2010: Report & Analysis Tools
- Creating a PivotTable
- Using your PivotTable
- Creating a PivotChart
- Creating a quick report
- Creating your own database report
- Creating a report to analyze your database's properties
- Cleaning up your database
- Analyzing your database
Overview/Description
A PivotTable can be used to change how data is visualized and help with analyzing database records. Discover how to create and use PivotTables and PivotCharts, and use database reporting and cleanup in Access 2010.
Target
Prerequisites: none
Access 2010: Saving, Protecting, & Exporting Databases
Lesson Objectives
Access 2010: Saving, Protecting, & Exporting Databases
- Saving your data
- Protecting your database
- Backing up your database
- Exporting your database
- Sharing a table via email
Overview/Description
In order to get the most out of Access 2010, you need to understand how to use it. Discover how to save, protect, back up, and export data. Also, learn how to share a table via email.
Target
Prerequisites: none
Access 2010: Understanding Tables, Fields, & Entries
Lesson Objectives
Access 2010: Understanding Tables, Fields, & Entries
- Understanding your database
- Creating a table
- Managing your tables
- Inserting fields in your table
- Editing fields in your table
- Editing your database field properties
- Linking data in different tables
- Managing data relationships
- Visualizing object dependencies
Overview/Description
Within a database, data is stored and organized in tables. Discover how to create and manage tables, insert and edit fields and field properties, link table data, and manage relationships in Access 2010.
Target
Prerequisites: none
Access 2010: Working with Databases
Lesson Objectives
Access 2010: Working with Databases
- Creating a database
- Understanding the interface
- Modifying the default navigation settings
- Customizing the interface
- Adjusting your program settings
Overview/Description
An Access 2010 database allows you to store data for a variety of different purposes. Discover how to create a database, use and customize the interface, modify default navigation settings, and adjust program settings.
Target
Prerequisites: none
Creating Basic Tables in Access 2010
Lesson Objectives
Creating Basic Tables in Access 2010
- recognize the correct naming convention for tables
- create tables in Design view
- create tables in Datasheet view
- create a primary key for a table
- create input masks for table fields
- create indexes for table fields
- create validation rules
- modify tables
- create a basic table
- modify a basic table
Overview/Description
Microsoft Office Access 2010 makes it easy for you to create and modify database tables. This course discusses how basic tables are built, including creating fields and defining data types and properties, and how to modify them. It also demonstrates the use of primary keys, masked input fields, and indexing, as well as creating validation rules for the data.
Microsoft Office Access 2010 makes it easy for you to create and modify database tables. This course discusses how basic tables are built, including creating fields and defining data types and properties, and how to modify them. It also demonstrates the use of primary keys, masked input fields, and indexing, as well as creating validation rules for the data.
Prerequisites: none
Creating Basic Tables in Access 2010
Lesson Objectives
Creating Basic Tables in Access 2010
- recognize the correct naming convention for tables
- create tables in Design view
- create tables in Datasheet view
- create a primary key for a table
- create input masks for table fields
- create indexes for table fields
- create validation rules
- modify tables
- create a basic table
- modify a basic table
Overview/Description
Microsoft Office Access 2010 makes it easy for you to create and modify database tables. This course discusses how basic tables are built, including creating fields and defining data types and properties, and how to modify them. It also demonstrates the use of primary keys, masked input fields, and indexing, as well as creating validation rules for the data.
Microsoft Office Access 2010 makes it easy for you to create and modify database tables. This course discusses how basic tables are built, including creating fields and defining data types and properties, and how to modify them. It also demonstrates the use of primary keys, masked input fields, and indexing, as well as creating validation rules for the data.
Prerequisites: none
Data Manipulation and Simple Relationships in Access 2010
Lesson Objectives
Data Manipulation and Simple Relationships in Access 2010
- modify how data is presented in datasheets
- sort and filter records in datasheets
- find and replace data in records
- import data from an Excel spreadsheet into an Access database
- export data from one Access database to another
- recognize key characteristics of table relationships
- create table relationships in a database
- edit table relationships
- sort and filter records
- find and replace data
- import and export data
- create and edit table relationships in a database
Overview/Description
The ability to manipulate data, records, and relationships in Access 2010 is a valuable asset to any database administrator. Access 2010 provides you with the data manipulation and table relationship techniques necessary for reliable databases. This course demonstrates how to perform basic data manipulation tasks, how to import and export data, and how to implement and edit table relationships.
The ability to manipulate data, records, and relationships in Access 2010 is a valuable asset to any database administrator. Access 2010 provides you with the data manipulation and table relationship techniques necessary for reliable databases. This course demonstrates how to perform basic data manipulation tasks, how to import and export data, and how to implement and edit table relationships.
Prerequisites: none
Data Manipulation and Simple Relationships in Access 2010
Lesson Objectives
Data Manipulation and Simple Relationships in Access 2010
- modify how data is presented in datasheets
- sort and filter records in datasheets
- find and replace data in records
- import data from an Excel spreadsheet into an Access database
- export data from one Access database to another
- recognize key characteristics of table relationships
- create table relationships in a database
- edit table relationships
- sort and filter records
- find and replace data
- import and export data
- create and edit table relationships in a database
Overview/Description
The ability to manipulate data, records, and relationships in Access 2010 is a valuable asset to any database administrator. Access 2010 provides you with the data manipulation and table relationship techniques necessary for reliable databases. This course demonstrates how to perform basic data manipulation tasks, how to import and export data, and how to implement and edit table relationships.
The ability to manipulate data, records, and relationships in Access 2010 is a valuable asset to any database administrator. Access 2010 provides you with the data manipulation and table relationship techniques necessary for reliable databases. This course demonstrates how to perform basic data manipulation tasks, how to import and export data, and how to implement and edit table relationships.
Prerequisites: none
Getting Started with Access 2010
Lesson Objectives
Getting Started with Access 2010
- recognize the fundamentals of Access 2010 databases
- plan a basic Access 2010 database
- recognize key features of the Access 2010 interface and their functions
- create a database using a template
- create a blank database
- create a database from a template
- create a blank database
- add application parts to a database
Overview/Description
Access 2010 is the newest version of Microsoft's dynamic database management tool and it offers features that allow you to create and modify a variety of database types. The ribbon is unique to Microsoft Office and stacks the many features of Access into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all database file-level tools, such as those used for saving, creating databases and tables, and working with external data. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2010.
Access 2010 is the newest version of Microsoft's dynamic database management tool and it offers features that allow you to create and modify a variety of database types. The ribbon is unique to Microsoft Office and stacks the many features of Access into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all database file-level tools, such as those used for saving, creating databases and tables, and working with external data. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2010.
Prerequisites: none
Getting Started with Access 2010
Lesson Objectives
Getting Started with Access 2010
- recognize the fundamentals of Access 2010 databases
- plan a basic Access 2010 database
- recognize key features of the Access 2010 interface and their functions
- create a database using a template
- create a blank database
- create a database from a template
- create a blank database
- add application parts to a database
Overview/Description
Access 2010 is the newest version of Microsoft's dynamic database management tool and it offers features that allow you to create and modify a variety of database types. The ribbon is unique to Microsoft Office and stacks the many features of Access into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all database file-level tools, such as those used for saving, creating databases and tables, and working with external data. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2010.
Access 2010 is the newest version of Microsoft's dynamic database management tool and it offers features that allow you to create and modify a variety of database types. The ribbon is unique to Microsoft Office and stacks the many features of Access into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all database file-level tools, such as those used for saving, creating databases and tables, and working with external data. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2010.
Prerequisites: none
Introduction to Forms in Access 2010
Lesson Objectives
Introduction to Forms in Access 2010
- create basic forms
- recognize how Layout view and Design view are used when modifying basic forms
- configure controls on a form
- configure a Web Browser Control on a form
- configure input masks for bound controls
- configure a control that refers to a control in another form
- create a basic form
- configure controls on a form
Overview/Description
Microsoft Office Access 2010 offers several options for creating and managing forms and controls. This course describes how to create forms in Access 2010 and also explores controls - the available types, how they are added to a form, how their properties are set, and how they are resized, moved, grouped, and positioned on a form. It also demonstrates how to configure the Web Browser Control, which is a new feature of Access 2010.
Microsoft Office Access 2010 offers several options for creating and managing forms and controls. This course describes how to create forms in Access 2010 and also explores controls - the available types, how they are added to a form, how their properties are set, and how they are resized, moved, grouped, and positioned on a form. It also demonstrates how to configure the Web Browser Control, which is a new feature of Access 2010.
Prerequisites: none
Introduction to Forms in Access 2010
Lesson Objectives
Introduction to Forms in Access 2010
- create basic forms
- recognize how Layout view and Design view are used when modifying basic forms
- configure controls on a form
- configure a Web Browser Control on a form
- configure input masks for bound controls
- configure a control that refers to a control in another form
- create a basic form
- configure controls on a form
Overview/Description
Microsoft Office Access 2010 offers several options for creating and managing forms and controls. This course describes how to create forms in Access 2010 and also explores controls - the available types, how they are added to a form, how their properties are set, and how they are resized, moved, grouped, and positioned on a form. It also demonstrates how to configure the Web Browser Control, which is a new feature of Access 2010.
Microsoft Office Access 2010 offers several options for creating and managing forms and controls. This course describes how to create forms in Access 2010 and also explores controls - the available types, how they are added to a form, how their properties are set, and how they are resized, moved, grouped, and positioned on a form. It also demonstrates how to configure the Web Browser Control, which is a new feature of Access 2010.
Prerequisites: none
Introduction to Queries in Access 2010
Lesson Objectives
Introduction to Queries in Access 2010
- recognize the basic characteristics of queries
- create basic select queries
- modify queries
- use calculations to refine query data
- apply grouping and calculating functions to query results
- create crosstab queries
- create unmatched queries
- create find duplicates queries
- create and modify a Select query
- refine a query using groupings and calculations
- create a Crosstab query
- create a Find duplicates query
Overview/Description
Queries are used in Access 2010 to convert data into useful information and are an essential part of any database application. This course demonstrates how to create and modify a query in order to achieve specific results. It covers creating basic select queries, using Expression Builder, calculated fields, and grouping options for displaying query results. This course also demonstrates how to create crosstab, unmatched, and find duplicates queries.
Queries are used in Access 2010 to convert data into useful information and are an essential part of any database application. This course demonstrates how to create and modify a query in order to achieve specific results. It covers creating basic select queries, using Expression Builder, calculated fields, and grouping options for displaying query results. This course also demonstrates how to create crosstab, unmatched, and find duplicates queries.
Prerequisites: none
Introduction to Queries in Access 2010
Lesson Objectives
Introduction to Queries in Access 2010
- recognize the basic characteristics of queries
- create basic select queries
- modify queries
- use calculations to refine query data
- apply grouping and calculating functions to query results
- create crosstab queries
- create unmatched queries
- create find duplicates queries
- create and modify a Select query
- refine a query using groupings and calculations
- create a Crosstab query
- create a Find duplicates query
Overview/Description
Queries are used in Access 2010 to convert data into useful information and are an essential part of any database application. This course demonstrates how to create and modify a query in order to achieve specific results. It covers creating basic select queries, using Expression Builder, calculated fields, and grouping options for displaying query results. This course also demonstrates how to create crosstab, unmatched, and find duplicates queries.
Queries are used in Access 2010 to convert data into useful information and are an essential part of any database application. This course demonstrates how to create and modify a query in order to achieve specific results. It covers creating basic select queries, using Expression Builder, calculated fields, and grouping options for displaying query results. This course also demonstrates how to create crosstab, unmatched, and find duplicates queries.
Prerequisites: none
Introduction to Reports in Access 2010
Lesson Objectives
Introduction to Reports in Access 2010
- distinguish between the tools used to create reports
- create reports using client-compatible and web-compatible report tools
- create reports using non-web-compatible report tools
- organize Access reports
- add controls to a report
- apply data bars to a report control to present data
- create a chart in a report to present data
- create a report using a client-compatible and web-compatible report tool
- create a report using a non-web-compatible report tool
- group data in a report
- add controls to a report
Overview/Description
Reports are used in Access 2010 to convert data into useful information and are an essential part of any database application. Access 2010 provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, Report Design, and Labels. Also covered is how to add and bind controls, group and sort data, and perform calculations.
Reports are used in Access 2010 to convert data into useful information and are an essential part of any database application. Access 2010 provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, Report Design, and Labels. Also covered is how to add and bind controls, group and sort data, and perform calculations.
Prerequisites: none
Introduction to Reports in Access 2010
Lesson Objectives
Introduction to Reports in Access 2010
- distinguish between the tools used to create reports
- create reports using client-compatible and web-compatible report tools
- create reports using non-web-compatible report tools
- organize Access reports
- add controls to a report
- apply data bars to a report control to present data
- create a chart in a report to present data
- create a report using a client-compatible and web-compatible report tool
- create a report using a non-web-compatible report tool
- group data in a report
- add controls to a report
Overview/Description
Reports are used in Access 2010 to convert data into useful information and are an essential part of any database application. Access 2010 provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, Report Design, and Labels. Also covered is how to add and bind controls, group and sort data, and perform calculations.
Reports are used in Access 2010 to convert data into useful information and are an essential part of any database application. Access 2010 provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, Report Design, and Labels. Also covered is how to add and bind controls, group and sort data, and perform calculations.
Prerequisites: none
Modifying Basic Forms in Access 2010
Lesson Objectives
Modifying Basic Forms in Access 2010
- customize forms
- format forms by creating your own themes
- manage records in forms
- sort and filter records in forms
- work with navigation forms
- use a theme to format a form
- manage records in forms
- create a navigation form
Overview/Description
Access 2010 allows you to make a variety of changes to the look and feel of a form. These changes range from resizing columns and controls to applying Office 2010 themes and managing records in a form. Access 2010 also introduces a new form type, the navigation form, which you can use as a switchboard to navigate the various objects in a database. This course covers how to use these methods to customize and format forms in Access 2010 as well as how to create and modify navigation forms.
Access 2010 allows you to make a variety of changes to the look and feel of a form. These changes range from resizing columns and controls to applying Office 2010 themes and managing records in a form. Access 2010 also introduces a new form type, the navigation form, which you can use as a switchboard to navigate the various objects in a database. This course covers how to use these methods to customize and format forms in Access 2010 as well as how to create and modify navigation forms.
Prerequisites: none
Modifying Basic Forms in Access 2010
Lesson Objectives
Modifying Basic Forms in Access 2010
- customize forms
- format forms by creating your own themes
- manage records in forms
- sort and filter records in forms
- work with navigation forms
- use a theme to format a form
- manage records in forms
- create a navigation form
Overview/Description
Access 2010 allows you to make a variety of changes to the look and feel of a form. These changes range from resizing columns and controls to applying Office 2010 themes and managing records in a form. Access 2010 also introduces a new form type, the navigation form, which you can use as a switchboard to navigate the various objects in a database. This course covers how to use these methods to customize and format forms in Access 2010 as well as how to create and modify navigation forms.
Access 2010 allows you to make a variety of changes to the look and feel of a form. These changes range from resizing columns and controls to applying Office 2010 themes and managing records in a form. Access 2010 also introduces a new form type, the navigation form, which you can use as a switchboard to navigate the various objects in a database. This course covers how to use these methods to customize and format forms in Access 2010 as well as how to create and modify navigation forms.
Prerequisites: none
